﻿CREATE TABLE [flcr].[UTIL_MEASURES_TYPE] (
    [UTIL_MEASURES_TYPE_ID]    INT           NOT NULL,
    [AUDIT_USER]               VARCHAR (100) NOT NULL,
    [AUDIT_DTTM]               DATETIME      NOT NULL,
    [AUDIT_DTTM_TZ]            INT           NOT NULL,
    [AUDIT_MOD_USER]           VARCHAR (100) NOT NULL,
    [AUDIT_MOD_DTTM]           DATETIME      NOT NULL,
    [AUDIT_MOD_DTTM_TZ]        INT           NOT NULL,
    [BUILTIN]                  BIT           NOT NULL,
    [ACTIVE_FLG]               BIT           NOT NULL,
    [SORT_ORDER]               INT           NOT NULL,
    [UTIL_MEASURE_TYPE]        INT           NOT NULL,
    [UTIL_MEASURE_TYPE_NAME]   VARCHAR (100) NOT NULL,
    [UTIL_MEASURE_TYPE_DESC]   VARCHAR (250) NOT NULL,
    [UTIL_MEASURES_TYPE_GROUP] INT           NOT NULL,
    [PARENT_ID]                INT           NULL
);

